﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="HomeCareDataSet" targetNamespace="http://tempuri.org/HomeCareDataSet.xsd" xmlns:mstns="http://tempuri.org/HomeCareDataSet.xsd" xmlns="http://tempuri.org/HomeCareDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="HomeCareConnection" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HomeCareConnection (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HomeCare.Properties.Settings.GlobalReference.Default.HomeCareConnection" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AcessosTableAdapter" GeneratorDataComponentClassName="AcessosTableAdapter" Name="Acessos" UserDataComponentName="AcessosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Acessos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Acessos] WHERE (([ID] = @Original_ID) AND ([Telas_ID] = @Original_Telas_ID) AND ([Perfis_ID] = @Original_Perfis_ID) AND ((@IsNull_Alteracao = 1 AND [Alteracao] IS NULL) OR ([Alteracao] = @Original_Alteracao)) AND ((@IsNull_Consulta = 1 AND [Consulta] IS NULL) OR ([Consulta] = @Original_Consulta)) AND ((@IsNull_Exclusao = 1 AND [Exclusao] IS NULL) OR ([Exclusao] = @Original_Exclusao)) AND ((@IsNull_Inclusao = 1 AND [Inclusao] IS NULL) OR ([Inclusao] = @Original_Inclusao)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Telas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Perfis_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Alteracao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Alteracao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Alteracao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Alteracao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Consulta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consulta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Consulta" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Consulta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Exclusao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Exclusao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Exclusao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Exclusao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Inclusao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Inclusao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Inclusao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inclusao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Acessos] ([Telas_ID], [Perfis_ID], [Alteracao], [Consulta], [Exclusao], [Inclusao]) VALUES (@Telas_ID, @Perfis_ID, @Alteracao, @Consulta, @Exclusao, @Inclusao);
SELECT ID, Telas_ID, Perfis_ID, Alteracao, Consulta, Exclusao, Inclusao FROM Acessos WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Telas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Perfis_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Alteracao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Alteracao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Consulta" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Consulta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Exclusao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Exclusao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inclusao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inclusao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Telas_ID, Perfis_ID, Alteracao, Consulta, Exclusao, Inclusao FROM dbo.Acessos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Acessos] SET [Telas_ID] = @Telas_ID, [Perfis_ID] = @Perfis_ID, [Alteracao] = @Alteracao, [Consulta] = @Consulta, [Exclusao] = @Exclusao, [Inclusao] = @Inclusao WHERE (([ID] = @Original_ID) AND ([Telas_ID] = @Original_Telas_ID) AND ([Perfis_ID] = @Original_Perfis_ID) AND ((@IsNull_Alteracao = 1 AND [Alteracao] IS NULL) OR ([Alteracao] = @Original_Alteracao)) AND ((@IsNull_Consulta = 1 AND [Consulta] IS NULL) OR ([Consulta] = @Original_Consulta)) AND ((@IsNull_Exclusao = 1 AND [Exclusao] IS NULL) OR ([Exclusao] = @Original_Exclusao)) AND ((@IsNull_Inclusao = 1 AND [Inclusao] IS NULL) OR ([Inclusao] = @Original_Inclusao)));
SELECT ID, Telas_ID, Perfis_ID, Alteracao, Consulta, Exclusao, Inclusao FROM Acessos WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Telas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Perfis_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Alteracao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Alteracao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Consulta" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Consulta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Exclusao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Exclusao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inclusao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inclusao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Telas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Perfis_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Alteracao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Alteracao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Alteracao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Alteracao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Consulta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consulta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Consulta" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Consulta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Exclusao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Exclusao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Exclusao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Exclusao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Inclusao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Inclusao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Inclusao" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inclusao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Acessos" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Telas_ID" DataSetColumn="Telas_ID" />
              <Mapping SourceColumn="Perfis_ID" DataSetColumn="Perfis_ID" />
              <Mapping SourceColumn="Alteracao" DataSetColumn="Alteracao" />
              <Mapping SourceColumn="Consulta" DataSetColumn="Consulta" />
              <Mapping SourceColumn="Exclusao" DataSetColumn="Exclusao" />
              <Mapping SourceColumn="Inclusao" DataSetColumn="Inclusao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AgendaTableAdapter" GeneratorDataComponentClassName="AgendaTableAdapter" Name="Agenda" UserDataComponentName="AgendaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Agenda" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Agenda] WHERE (([ID] = @Original_ID) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ((@IsNull_Funcionario_ID = 1 AND [Funcionario_ID] IS NULL) OR ([Funcionario_ID] = @Original_Funcionario_ID)) AND ((@IsNull_DtFinal = 1 AND [DtFinal] IS NULL) OR ([DtFinal] = @Original_DtFinal)) AND ((@IsNull_DtInicial = 1 AND [DtInicial] IS NULL) OR ([DtInicial] = @Original_DtInicial)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Funcionario_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funcionario_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Funcionario_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funcionario_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DtFinal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DtFinal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DtFinal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtFinal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DtInicial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DtInicial" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DtInicial" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtInicial" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Agenda] ([Pessoas_ID], [Funcionario_ID], [DtFinal], [DtInicial]) VALUES (@Pessoas_ID, @Funcionario_ID, @DtFinal, @DtInicial);
SELECT ID, Pessoas_ID, Funcionario_ID, DtFinal, DtInicial FROM Agenda WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Funcionario_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funcionario_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtFinal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtFinal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtInicial" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtInicial" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Pessoas_ID, Funcionario_ID, DtFinal, DtInicial FROM dbo.Agenda</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Agenda] SET [Pessoas_ID] = @Pessoas_ID, [Funcionario_ID] = @Funcionario_ID, [DtFinal] = @DtFinal, [DtInicial] = @DtInicial WHERE (([ID] = @Original_ID) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ((@IsNull_Funcionario_ID = 1 AND [Funcionario_ID] IS NULL) OR ([Funcionario_ID] = @Original_Funcionario_ID)) AND ((@IsNull_DtFinal = 1 AND [DtFinal] IS NULL) OR ([DtFinal] = @Original_DtFinal)) AND ((@IsNull_DtInicial = 1 AND [DtInicial] IS NULL) OR ([DtInicial] = @Original_DtInicial)));
SELECT ID, Pessoas_ID, Funcionario_ID, DtFinal, DtInicial FROM Agenda WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Funcionario_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funcionario_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtFinal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtFinal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtInicial" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtInicial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Funcionario_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funcionario_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Funcionario_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funcionario_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DtFinal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DtFinal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DtFinal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtFinal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DtInicial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DtInicial" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DtInicial" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtInicial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Agenda" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Funcionario_ID" DataSetColumn="Funcionario_ID" />
              <Mapping SourceColumn="DtFinal" DataSetColumn="DtFinal" />
              <Mapping SourceColumn="DtInicial" DataSetColumn="DtInicial" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BairrosTableAdapter" GeneratorDataComponentClassName="BairrosTableAdapter" Name="Bairros" UserDataComponentName="BairrosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Bairros" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Bairros] WHERE (([ID] = @Original_ID) AND ([Cidades_ID] = @Original_Cidades_ID) AND ((@IsNull_Bairro = 1 AND [Bairro] IS NULL) OR ([Bairro] = @Original_Bairro)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidades_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Bairro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Bairros] ([Cidades_ID], [Bairro]) VALUES (@Cidades_ID, @Bairro);
SELECT ID, Cidades_ID, Bairro FROM Bairros WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidades_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Cidades_ID, Bairro FROM dbo.Bairros</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Bairros] SET [Cidades_ID] = @Cidades_ID, [Bairro] = @Bairro WHERE (([ID] = @Original_ID) AND ([Cidades_ID] = @Original_Cidades_ID) AND ((@IsNull_Bairro = 1 AND [Bairro] IS NULL) OR ([Bairro] = @Original_Bairro)));
SELECT ID, Cidades_ID, Bairro FROM Bairros WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidades_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidades_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Bairro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Bairros" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Cidades_ID" DataSetColumn="Cidades_ID" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CidadesTableAdapter" GeneratorDataComponentClassName="CidadesTableAdapter" Name="Cidades" UserDataComponentName="CidadesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Cidades" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cidades] WHERE (([ID] = @Original_ID) AND ([Estados_ID] = @Original_Estados_ID) AND ((@IsNull_Cidade = 1 AND [Cidade] IS NULL) OR ([Cidade] = @Original_Cidade)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Estados_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estados_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cidade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cidades] ([Estados_ID], [Cidade]) VALUES (@Estados_ID, @Cidade);
SELECT ID, Estados_ID, Cidade FROM Cidades WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Estados_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estados_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Estados_ID, Cidade FROM dbo.Cidades</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cidades] SET [Estados_ID] = @Estados_ID, [Cidade] = @Cidade WHERE (([ID] = @Original_ID) AND ([Estados_ID] = @Original_Estados_ID) AND ((@IsNull_Cidade = 1 AND [Cidade] IS NULL) OR ([Cidade] = @Original_Cidade)));
SELECT ID, Estados_ID, Cidade FROM Cidades WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Estados_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estados_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Estados_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estados_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cidade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Cidades" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Estados_ID" DataSetColumn="Estados_ID" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EnderecosTableAdapter" GeneratorDataComponentClassName="EnderecosTableAdapter" Name="Enderecos" UserDataComponentName="EnderecosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Enderecos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Enderecos] WHERE (([ID] = @Original_ID) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ([Estados_ID] = @Original_Estados_ID) AND ([Cidades_ID] = @Original_Cidades_ID) AND ([Bairros_ID] = @Original_Bairros_ID) AND ((@IsNull_Rua = 1 AND [Rua] IS NULL) OR ([Rua] = @Original_Rua)) AND ((@IsNull_Numero = 1 AND [Numero] IS NULL) OR ([Numero] = @Original_Numero)) AND ((@IsNull_Complemento = 1 AND [Complemento] IS NULL) OR ([Complemento] = @Original_Complemento)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Estados_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estados_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidades_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Bairros_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bairros_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Complemento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Complemento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Complemento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Complemento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Enderecos] ([Pessoas_ID], [Estados_ID], [Cidades_ID], [Bairros_ID], [Rua], [Numero], [Complemento]) VALUES (@Pessoas_ID, @Estados_ID, @Cidades_ID, @Bairros_ID, @Rua, @Numero, @Complemento);
SELECT ID, Pessoas_ID, Estados_ID, Cidades_ID, Bairros_ID, Rua, Numero, Complemento FROM Enderecos WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Estados_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estados_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidades_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Bairros_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bairros_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Complemento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Complemento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Pessoas_ID, Estados_ID, Cidades_ID, Bairros_ID, Rua, Numero, Complemento FROM dbo.Enderecos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Enderecos] SET [Pessoas_ID] = @Pessoas_ID, [Estados_ID] = @Estados_ID, [Cidades_ID] = @Cidades_ID, [Bairros_ID] = @Bairros_ID, [Rua] = @Rua, [Numero] = @Numero, [Complemento] = @Complemento WHERE (([ID] = @Original_ID) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ([Estados_ID] = @Original_Estados_ID) AND ([Cidades_ID] = @Original_Cidades_ID) AND ([Bairros_ID] = @Original_Bairros_ID) AND ((@IsNull_Rua = 1 AND [Rua] IS NULL) OR ([Rua] = @Original_Rua)) AND ((@IsNull_Numero = 1 AND [Numero] IS NULL) OR ([Numero] = @Original_Numero)) AND ((@IsNull_Complemento = 1 AND [Complemento] IS NULL) OR ([Complemento] = @Original_Complemento)));
SELECT ID, Pessoas_ID, Estados_ID, Cidades_ID, Bairros_ID, Rua, Numero, Complemento FROM Enderecos WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Estados_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estados_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidades_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Bairros_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bairros_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Complemento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Complemento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Estados_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estados_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cidades_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Bairros_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bairros_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Complemento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Complemento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Complemento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Complemento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Enderecos" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Estados_ID" DataSetColumn="Estados_ID" />
              <Mapping SourceColumn="Cidades_ID" DataSetColumn="Cidades_ID" />
              <Mapping SourceColumn="Bairros_ID" DataSetColumn="Bairros_ID" />
              <Mapping SourceColumn="Rua" DataSetColumn="Rua" />
              <Mapping SourceColumn="Numero" DataSetColumn="Numero" />
              <Mapping SourceColumn="Complemento" DataSetColumn="Complemento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EnfermidadesTableAdapter" GeneratorDataComponentClassName="EnfermidadesTableAdapter" Name="Enfermidades" UserDataComponentName="EnfermidadesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Enfermidades" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Enfermidades] WHERE (([ID] = @Original_ID) AND ((@IsNull_Descricao = 1 AND [Descricao] IS NULL) OR ([Descricao] = @Original_Descricao)) AND ((@IsNull_Enfermidade = 1 AND [Enfermidade] IS NULL) OR ([Enfermidade] = @Original_Enfermidade)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descricao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Enfermidade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Enfermidade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Enfermidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Enfermidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Enfermidades] ([Descricao], [Enfermidade]) VALUES (@Descricao, @Enfermidade);
SELECT ID, Descricao, Enfermidade FROM Enfermidades WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Enfermidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Enfermidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Descricao, Enfermidade FROM dbo.Enfermidades</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Enfermidades] SET [Descricao] = @Descricao, [Enfermidade] = @Enfermidade WHERE (([ID] = @Original_ID) AND ((@IsNull_Descricao = 1 AND [Descricao] IS NULL) OR ([Descricao] = @Original_Descricao)) AND ((@IsNull_Enfermidade = 1 AND [Enfermidade] IS NULL) OR ([Enfermidade] = @Original_Enfermidade)));
SELECT ID, Descricao, Enfermidade FROM Enfermidades WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Enfermidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Enfermidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descricao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Enfermidade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Enfermidade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Enfermidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Enfermidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Enfermidades" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
              <Mapping SourceColumn="Enfermidade" DataSetColumn="Enfermidade" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EquipeMedicaTableAdapter" GeneratorDataComponentClassName="EquipeMedicaTableAdapter" Name="EquipeMedica" UserDataComponentName="EquipeMedicaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.EquipeMedica" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EquipeMedica] WHERE (([ID] = @Original_ID) AND ((@IsNull_NomeEquipe = 1 AND [NomeEquipe] IS NULL) OR ([NomeEquipe] = @Original_NomeEquipe)) AND ((@IsNull_Medico_Resp_ID = 1 AND [Medico_Resp_ID] IS NULL) OR ([Medico_Resp_ID] = @Original_Medico_Resp_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NomeEquipe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NomeEquipe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NomeEquipe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NomeEquipe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Medico_Resp_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico_Resp_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Medico_Resp_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico_Resp_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EquipeMedica] ([NomeEquipe], [Medico_Resp_ID]) VALUES (@NomeEquipe, @Medico_Resp_ID);
SELECT ID, NomeEquipe, Medico_Resp_ID FROM EquipeMedica WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NomeEquipe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NomeEquipe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medico_Resp_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico_Resp_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, NomeEquipe, Medico_Resp_ID FROM dbo.EquipeMedica</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EquipeMedica] SET [NomeEquipe] = @NomeEquipe, [Medico_Resp_ID] = @Medico_Resp_ID WHERE (([ID] = @Original_ID) AND ((@IsNull_NomeEquipe = 1 AND [NomeEquipe] IS NULL) OR ([NomeEquipe] = @Original_NomeEquipe)) AND ((@IsNull_Medico_Resp_ID = 1 AND [Medico_Resp_ID] IS NULL) OR ([Medico_Resp_ID] = @Original_Medico_Resp_ID)));
SELECT ID, NomeEquipe, Medico_Resp_ID FROM EquipeMedica WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NomeEquipe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NomeEquipe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medico_Resp_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico_Resp_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NomeEquipe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NomeEquipe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NomeEquipe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NomeEquipe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Medico_Resp_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico_Resp_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Medico_Resp_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico_Resp_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.EquipeMedica" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="NomeEquipe" DataSetColumn="NomeEquipe" />
              <Mapping SourceColumn="Medico_Resp_ID" DataSetColumn="Medico_Resp_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EquipeMedica_has_PessoasTableAdapter" GeneratorDataComponentClassName="EquipeMedica_has_PessoasTableAdapter" Name="EquipeMedica_has_Pessoas" UserDataComponentName="EquipeMedica_has_PessoasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.EquipeMedica_has_Pessoas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EquipeMedica_has_Pessoas] WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ([EquipeMedica_ID] = @Original_EquipeMedica_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EquipeMedica_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeMedica_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EquipeMedica_has_Pessoas] ([Pessoas_ID], [EquipeMedica_ID]) VALUES (@Pessoas_ID, @EquipeMedica_ID);
SELECT Pessoas_ID, EquipeMedica_ID FROM EquipeMedica_has_Pessoas WHERE (EquipeMedica_ID = @EquipeMedica_ID) AND (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EquipeMedica_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeMedica_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Pessoas_ID, EquipeMedica_ID FROM dbo.EquipeMedica_has_Pessoas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EquipeMedica_has_Pessoas] SET [Pessoas_ID] = @Pessoas_ID, [EquipeMedica_ID] = @EquipeMedica_ID WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ([EquipeMedica_ID] = @Original_EquipeMedica_ID));
SELECT Pessoas_ID, EquipeMedica_ID FROM EquipeMedica_has_Pessoas WHERE (EquipeMedica_ID = @EquipeMedica_ID) AND (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EquipeMedica_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeMedica_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EquipeMedica_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipeMedica_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="EquipeMedica_ID" DataSetColumn="EquipeMedica_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EspecialidadesTableAdapter" GeneratorDataComponentClassName="EspecialidadesTableAdapter" Name="Especialidades" UserDataComponentName="EspecialidadesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Especialidades" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Especialidades] WHERE (([ID] = @Original_ID) AND ((@IsNull_Especialidade = 1 AND [Especialidade] IS NULL) OR ([Especialidade] = @Original_Especialidade)) AND ((@IsNull_Descricao = 1 AND [Descricao] IS NULL) OR ([Descricao] = @Original_Descricao)) AND ((@IsNull_Registro = 1 AND [Registro] IS NULL) OR ([Registro] = @Original_Registro)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Especialidade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Especialidade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Especialidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Especialidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descricao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Registro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Registro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Registro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Registro" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Especialidades] ([Especialidade], [Descricao], [Registro]) VALUES (@Especialidade, @Descricao, @Registro);
SELECT ID, Especialidade, Descricao, Registro FROM Especialidades WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Especialidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Especialidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Registro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Registro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Especialidade, Descricao, Registro FROM dbo.Especialidades</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Especialidades] SET [Especialidade] = @Especialidade, [Descricao] = @Descricao, [Registro] = @Registro WHERE (([ID] = @Original_ID) AND ((@IsNull_Especialidade = 1 AND [Especialidade] IS NULL) OR ([Especialidade] = @Original_Especialidade)) AND ((@IsNull_Descricao = 1 AND [Descricao] IS NULL) OR ([Descricao] = @Original_Descricao)) AND ((@IsNull_Registro = 1 AND [Registro] IS NULL) OR ([Registro] = @Original_Registro)));
SELECT ID, Especialidade, Descricao, Registro FROM Especialidades WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Especialidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Especialidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Registro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Registro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Especialidade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Especialidade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Especialidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Especialidade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descricao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Registro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Registro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Registro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Registro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Especialidades" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Especialidade" DataSetColumn="Especialidade" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
              <Mapping SourceColumn="Registro" DataSetColumn="Registro" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EstadosTableAdapter" GeneratorDataComponentClassName="EstadosTableAdapter" Name="Estados" UserDataComponentName="EstadosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Estados" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Estados] WHERE (([ID] = @Original_ID) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Estados] ([Nome], [Sigla]) VALUES (@Nome, @Sigla);
SELECT ID, Nome, Sigla FROM Estados WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Nome, Sigla FROM dbo.Estados</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Estados] SET [Nome] = @Nome, [Sigla] = @Sigla WHERE (([ID] = @Original_ID) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)));
SELECT ID, Nome, Sigla FROM Estados WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Estados" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Sigla" DataSetColumn="Sigla" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EventosTableAdapter" GeneratorDataComponentClassName="EventosTableAdapter" Name="Eventos" UserDataComponentName="EventosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Eventos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Eventos] WHERE (([idEventos] = @Original_idEventos) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ([Telas_ID] = @Original_Telas_ID) AND ((@IsNull_DtEvento = 1 AND [DtEvento] IS NULL) OR ([DtEvento] = @Original_DtEvento)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idEventos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEventos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Telas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DtEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DtEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DtEvento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Eventos] ([Pessoas_ID], [Telas_ID], [DtEvento]) VALUES (@Pessoas_ID, @Telas_ID, @DtEvento);
SELECT idEventos, Pessoas_ID, Telas_ID, DtEvento FROM Eventos WHERE (idEventos = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Telas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtEvento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idEventos, Pessoas_ID, Telas_ID, DtEvento FROM dbo.Eventos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Eventos] SET [Pessoas_ID] = @Pessoas_ID, [Telas_ID] = @Telas_ID, [DtEvento] = @DtEvento WHERE (([idEventos] = @Original_idEventos) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ([Telas_ID] = @Original_Telas_ID) AND ((@IsNull_DtEvento = 1 AND [DtEvento] IS NULL) OR ([DtEvento] = @Original_DtEvento)));
SELECT idEventos, Pessoas_ID, Telas_ID, DtEvento FROM Eventos WHERE (idEventos = @idEventos)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Telas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtEvento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtEvento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idEventos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEventos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Telas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DtEvento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DtEvento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DtEvento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtEvento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idEventos" ColumnName="idEventos" DataSourceName="HomeCare.dbo.Eventos" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idEventos" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idEventos" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idEventos" DataSetColumn="idEventos" />
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Telas_ID" DataSetColumn="Telas_ID" />
              <Mapping SourceColumn="DtEvento" DataSetColumn="DtEvento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FotografiasTableAdapter" GeneratorDataComponentClassName="FotografiasTableAdapter" Name="Fotografias" UserDataComponentName="FotografiasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Fotografias" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Fotografias] WHERE (([ID] = @Original_ID) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ((@IsNull_Caminho = 1 AND [Caminho] IS NULL) OR ([Caminho] = @Original_Caminho)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Caminho" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Caminho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Caminho" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Caminho" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Fotografias] ([Pessoas_ID], [Caminho]) VALUES (@Pessoas_ID, @Caminho);
SELECT ID, Pessoas_ID, Caminho FROM Fotografias WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Caminho" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Caminho" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Pessoas_ID, Caminho FROM dbo.Fotografias</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Fotografias] SET [Pessoas_ID] = @Pessoas_ID, [Caminho] = @Caminho WHERE (([ID] = @Original_ID) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ((@IsNull_Caminho = 1 AND [Caminho] IS NULL) OR ([Caminho] = @Original_Caminho)));
SELECT ID, Pessoas_ID, Caminho FROM Fotografias WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Caminho" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Caminho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Caminho" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Caminho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Caminho" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Caminho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Fotografias" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Caminho" DataSetColumn="Caminho" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HistoricoTableAdapter" GeneratorDataComponentClassName="HistoricoTableAdapter" Name="Historico" UserDataComponentName="HistoricoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Historico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Historico] ([Pessoas_ID], [Funcionario_ID], [Situacao_ID], [Medicamentos_ID], [DtHistorico], [Procedimento]) VALUES (@Pessoas_ID, @Funcionario_ID, @Situacao_ID, @Medicamentos_ID, @DtHistorico, @Procedimento)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Funcionario_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Funcionario_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Situacao_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Situacao_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medicamentos_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medicamentos_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtHistorico" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtHistorico" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Procedimento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Procedimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Pessoas_ID, Funcionario_ID, Situacao_ID, Medicamentos_ID, DtHistorico, Procedimento FROM dbo.Historico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Funcionario_ID" DataSetColumn="Funcionario_ID" />
              <Mapping SourceColumn="Situacao_ID" DataSetColumn="Situacao_ID" />
              <Mapping SourceColumn="Medicamentos_ID" DataSetColumn="Medicamentos_ID" />
              <Mapping SourceColumn="DtHistorico" DataSetColumn="DtHistorico" />
              <Mapping SourceColumn="Procedimento" DataSetColumn="Procedimento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MedicamentosTableAdapter" GeneratorDataComponentClassName="MedicamentosTableAdapter" Name="Medicamentos" UserDataComponentName="MedicamentosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Medicamentos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Medicamentos] WHERE (([ID] = @Original_ID) AND ((@IsNull_Medicamento = 1 AND [Medicamento] IS NULL) OR ([Medicamento] = @Original_Medicamento)) AND ((@IsNull_Classificacao = 1 AND [Classificacao] IS NULL) OR ([Classificacao] = @Original_Classificacao)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Medicamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medicamento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Medicamento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Medicamento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Classificacao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Classificacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Classificacao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Classificacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Medicamentos] ([Medicamento], [Classificacao]) VALUES (@Medicamento, @Classificacao);
SELECT ID, Medicamento, Classificacao FROM Medicamentos WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Medicamento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Medicamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Classificacao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Classificacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Medicamento, Classificacao FROM dbo.Medicamentos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Medicamentos] SET [Medicamento] = @Medicamento, [Classificacao] = @Classificacao WHERE (([ID] = @Original_ID) AND ((@IsNull_Medicamento = 1 AND [Medicamento] IS NULL) OR ([Medicamento] = @Original_Medicamento)) AND ((@IsNull_Classificacao = 1 AND [Classificacao] IS NULL) OR ([Classificacao] = @Original_Classificacao)));
SELECT ID, Medicamento, Classificacao FROM Medicamentos WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Medicamento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Medicamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Classificacao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Classificacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Medicamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medicamento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Medicamento" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Medicamento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Classificacao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Classificacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Classificacao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Classificacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Medicamentos" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Medicamento" DataSetColumn="Medicamento" />
              <Mapping SourceColumn="Classificacao" DataSetColumn="Classificacao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PerfisTableAdapter" GeneratorDataComponentClassName="PerfisTableAdapter" Name="Perfis" UserDataComponentName="PerfisTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Perfis" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Perfis] WHERE (([ID] = @Original_ID) AND ((@IsNull_Perfis = 1 AND [Perfis] IS NULL) OR ([Perfis] = @Original_Perfis)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Perfis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Perfis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Perfis" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Perfis] ([Perfis], [Descricao]) VALUES (@Perfis, @Descricao);
SELECT ID, Perfis, Descricao FROM Perfis WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Perfis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Perfis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Perfis, Descricao FROM dbo.Perfis</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Perfis] SET [Perfis] = @Perfis, [Descricao] = @Descricao WHERE (([ID] = @Original_ID) AND ((@IsNull_Perfis = 1 AND [Perfis] IS NULL) OR ([Perfis] = @Original_Perfis)));
SELECT ID, Perfis, Descricao FROM Perfis WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Perfis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Perfis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Perfis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Perfis" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Perfis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Perfis" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Perfis" DataSetColumn="Perfis" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PessoasTableAdapter" GeneratorDataComponentClassName="PessoasTableAdapter" Name="Pessoas" UserDataComponentName="PessoasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Pessoas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Pessoas] WHERE (([ID] = @Original_ID) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ((@IsNull_Sexo = 1 AND [Sexo] IS NULL) OR ([Sexo] = @Original_Sexo)) AND ((@IsNull_DtNasc = 1 AND [DtNasc] IS NULL) OR ([DtNasc] = @Original_DtNasc)) AND ((@IsNull_CPF = 1 AND [CPF] IS NULL) OR ([CPF] = @Original_CPF)) AND ((@IsNull_RG = 1 AND [RG] IS NULL) OR ([RG] = @Original_RG)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Senha = 1 AND [Senha] IS NULL) OR ([Senha] = @Original_Senha)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sexo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sexo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DtNasc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DtNasc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DtNasc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtNasc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CPF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CPF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RG" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RG" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RG" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Senha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Senha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Pessoas] ([Nome], [Sexo], [DtNasc], [CPF], [RG], [Observacoes], [Login], [Senha]) VALUES (@Nome, @Sexo, @DtNasc, @CPF, @RG, @Observacoes, @Login, @Senha);
SELECT ID, Nome, Sexo, DtNasc, CPF, RG, Observacoes, Login, Senha FROM Pessoas WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sexo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtNasc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtNasc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CPF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RG" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RG" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observacoes" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Observacoes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Senha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Nome, Sexo, DtNasc, CPF, RG, Observacoes, Login, Senha FROM dbo.Pessoas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Pessoas] SET [Nome] = @Nome, [Sexo] = @Sexo, [DtNasc] = @DtNasc, [CPF] = @CPF, [RG] = @RG, [Observacoes] = @Observacoes, [Login] = @Login, [Senha] = @Senha WHERE (([ID] = @Original_ID) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ((@IsNull_Sexo = 1 AND [Sexo] IS NULL) OR ([Sexo] = @Original_Sexo)) AND ((@IsNull_DtNasc = 1 AND [DtNasc] IS NULL) OR ([DtNasc] = @Original_DtNasc)) AND ((@IsNull_CPF = 1 AND [CPF] IS NULL) OR ([CPF] = @Original_CPF)) AND ((@IsNull_RG = 1 AND [RG] IS NULL) OR ([RG] = @Original_RG)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Senha = 1 AND [Senha] IS NULL) OR ([Senha] = @Original_Senha)));
SELECT ID, Nome, Sexo, DtNasc, CPF, RG, Observacoes, Login, Senha FROM Pessoas WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sexo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DtNasc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtNasc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CPF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RG" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RG" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observacoes" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Observacoes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Senha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nome" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sexo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sexo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DtNasc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DtNasc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DtNasc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DtNasc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CPF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CPF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RG" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RG" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RG" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Senha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Senha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Pessoas" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Sexo" DataSetColumn="Sexo" />
              <Mapping SourceColumn="DtNasc" DataSetColumn="DtNasc" />
              <Mapping SourceColumn="CPF" DataSetColumn="CPF" />
              <Mapping SourceColumn="RG" DataSetColumn="RG" />
              <Mapping SourceColumn="Observacoes" DataSetColumn="Observacoes" />
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Senha" DataSetColumn="Senha" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Pessoas_has_EnfermidadesTableAdapter" GeneratorDataComponentClassName="Pessoas_has_EnfermidadesTableAdapter" Name="Pessoas_has_Enfermidades" UserDataComponentName="Pessoas_has_EnfermidadesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Pessoas_has_Enfermidades" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Pessoas_has_Enfermidades] WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ([Enfermidades_ID] = @Original_Enfermidades_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Enfermidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Enfermidades_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Pessoas_has_Enfermidades] ([Pessoas_ID], [Enfermidades_ID]) VALUES (@Pessoas_ID, @Enfermidades_ID);
SELECT Pessoas_ID, Enfermidades_ID FROM Pessoas_has_Enfermidades WHERE (Enfermidades_ID = @Enfermidades_ID) AND (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Enfermidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Enfermidades_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Pessoas_ID, Enfermidades_ID FROM dbo.Pessoas_has_Enfermidades</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Pessoas_has_Enfermidades] SET [Pessoas_ID] = @Pessoas_ID, [Enfermidades_ID] = @Enfermidades_ID WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ([Enfermidades_ID] = @Original_Enfermidades_ID));
SELECT Pessoas_ID, Enfermidades_ID FROM Pessoas_has_Enfermidades WHERE (Enfermidades_ID = @Enfermidades_ID) AND (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Enfermidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Enfermidades_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Enfermidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Enfermidades_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Enfermidades_ID" DataSetColumn="Enfermidades_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Pessoas_has_EspecialidadesTableAdapter" GeneratorDataComponentClassName="Pessoas_has_EspecialidadesTableAdapter" Name="Pessoas_has_Especialidades" UserDataComponentName="Pessoas_has_EspecialidadesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Pessoas_has_Especialidades" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Pessoas_has_Especialidades] WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ([Especialidades_ID] = @Original_Especialidades_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Especialidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Especialidades_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Pessoas_has_Especialidades] ([Pessoas_ID], [Especialidades_ID]) VALUES (@Pessoas_ID, @Especialidades_ID);
SELECT Pessoas_ID, Especialidades_ID FROM Pessoas_has_Especialidades WHERE (Especialidades_ID = @Especialidades_ID) AND (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Especialidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Especialidades_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Pessoas_ID, Especialidades_ID FROM dbo.Pessoas_has_Especialidades</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Pessoas_has_Especialidades] SET [Pessoas_ID] = @Pessoas_ID, [Especialidades_ID] = @Especialidades_ID WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ([Especialidades_ID] = @Original_Especialidades_ID));
SELECT Pessoas_ID, Especialidades_ID FROM Pessoas_has_Especialidades WHERE (Especialidades_ID = @Especialidades_ID) AND (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Especialidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Especialidades_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Especialidades_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Especialidades_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Especialidades_ID" DataSetColumn="Especialidades_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Pessoas_has_PerfisTableAdapter" GeneratorDataComponentClassName="Pessoas_has_PerfisTableAdapter" Name="Pessoas_has_Perfis" UserDataComponentName="Pessoas_has_PerfisTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Pessoas_has_Perfis" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Pessoas_has_Perfis] WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ([Perfis_ID] = @Original_Perfis_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Perfis_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Pessoas_has_Perfis] ([Pessoas_ID], [Perfis_ID]) VALUES (@Pessoas_ID, @Perfis_ID);
SELECT Pessoas_ID, Perfis_ID FROM Pessoas_has_Perfis WHERE (Perfis_ID = @Perfis_ID) AND (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Perfis_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Pessoas_ID, Perfis_ID FROM dbo.Pessoas_has_Perfis</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Pessoas_has_Perfis] SET [Pessoas_ID] = @Pessoas_ID, [Perfis_ID] = @Perfis_ID WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ([Perfis_ID] = @Original_Perfis_ID));
SELECT Pessoas_ID, Perfis_ID FROM Pessoas_has_Perfis WHERE (Perfis_ID = @Perfis_ID) AND (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Perfis_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Perfis_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perfis_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Perfis_ID" DataSetColumn="Perfis_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SituacaoTableAdapter" GeneratorDataComponentClassName="SituacaoTableAdapter" Name="Situacao" UserDataComponentName="SituacaoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Situacao" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Situacao] WHERE (([ID] = @Original_ID) AND ((@IsNull_Situacao = 1 AND [Situacao] IS NULL) OR ([Situacao] = @Original_Situacao)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Situacao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Situacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Situacao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Situacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Situacao] ([Situacao]) VALUES (@Situacao);
SELECT ID, Situacao FROM Situacao WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Situacao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Situacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Situacao FROM dbo.Situacao</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Situacao] SET [Situacao] = @Situacao WHERE (([ID] = @Original_ID) AND ((@IsNull_Situacao = 1 AND [Situacao] IS NULL) OR ([Situacao] = @Original_Situacao)));
SELECT ID, Situacao FROM Situacao WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Situacao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Situacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Situacao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Situacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Situacao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Situacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Situacao" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Situacao" DataSetColumn="Situacao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SMSTableAdapter" GeneratorDataComponentClassName="SMSTableAdapter" Name="SMS" UserDataComponentName="SMSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.SMS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SMS] WHERE (([ID] = @Original_ID) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ((@IsNull_Operadora = 1 AND [Operadora] IS NULL) OR ([Operadora] = @Original_Operadora)) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@IsNull_Mensagem = 1 AND [Mensagem] IS NULL) OR ([Mensagem] = @Original_Mensagem)) AND ((@IsNull_DataEnvio = 1 AND [DataEnvio] IS NULL) OR ([DataEnvio] = @Original_DataEnvio)) AND ((@IsNull_DDDTelefone = 1 AND [DDDTelefone] IS NULL) OR ([DDDTelefone] = @Original_DDDTelefone)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Operadora" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Operadora" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Operadora" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Operadora" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Telefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Mensagem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Mensagem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Mensagem" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mensagem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEnvio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEnvio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEnvio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEnvio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DDDTelefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DDDTelefone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DDDTelefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DDDTelefone" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SMS] ([Pessoas_ID], [Operadora], [Telefone], [Mensagem], [DataEnvio], [DDDTelefone]) VALUES (@Pessoas_ID, @Operadora, @Telefone, @Mensagem, @DataEnvio, @DDDTelefone);
SELECT ID, Pessoas_ID, Operadora, Telefone, Mensagem, DataEnvio, DDDTelefone FROM SMS WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Operadora" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Operadora" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Mensagem" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mensagem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEnvio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEnvio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DDDTelefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DDDTelefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Pessoas_ID, Operadora, Telefone, Mensagem, DataEnvio, DDDTelefone FROM dbo.SMS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SMS] SET [Pessoas_ID] = @Pessoas_ID, [Operadora] = @Operadora, [Telefone] = @Telefone, [Mensagem] = @Mensagem, [DataEnvio] = @DataEnvio, [DDDTelefone] = @DDDTelefone WHERE (([ID] = @Original_ID) AND ([Pessoas_ID] = @Original_Pessoas_ID) AND ((@IsNull_Operadora = 1 AND [Operadora] IS NULL) OR ([Operadora] = @Original_Operadora)) AND ((@IsNull_Telefone = 1 AND [Telefone] IS NULL) OR ([Telefone] = @Original_Telefone)) AND ((@IsNull_Mensagem = 1 AND [Mensagem] IS NULL) OR ([Mensagem] = @Original_Mensagem)) AND ((@IsNull_DataEnvio = 1 AND [DataEnvio] IS NULL) OR ([DataEnvio] = @Original_DataEnvio)) AND ((@IsNull_DDDTelefone = 1 AND [DDDTelefone] IS NULL) OR ([DDDTelefone] = @Original_DDDTelefone)));
SELECT ID, Pessoas_ID, Operadora, Telefone, Mensagem, DataEnvio, DDDTelefone FROM SMS WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Operadora" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Operadora" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Mensagem" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mensagem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataEnvio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEnvio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DDDTelefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DDDTelefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Operadora" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Operadora" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Operadora" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Operadora" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Telefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Mensagem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Mensagem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Mensagem" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mensagem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataEnvio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataEnvio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataEnvio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataEnvio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DDDTelefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DDDTelefone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DDDTelefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DDDTelefone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.SMS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="Operadora" DataSetColumn="Operadora" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Mensagem" DataSetColumn="Mensagem" />
              <Mapping SourceColumn="DataEnvio" DataSetColumn="DataEnvio" />
              <Mapping SourceColumn="DDDTelefone" DataSetColumn="DDDTelefone" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TelasTableAdapter" GeneratorDataComponentClassName="TelasTableAdapter" Name="Telas" UserDataComponentName="TelasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Telas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Telas] WHERE (([ID] = @Original_ID) AND ((@IsNull_Rotina = 1 AND [Rotina] IS NULL) OR ([Rotina] = @Original_Rotina)) AND ((@IsNull_Descricao = 1 AND [Descricao] IS NULL) OR ([Descricao] = @Original_Descricao)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rotina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rotina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Rotina" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rotina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descricao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Telas] ([Rotina], [Descricao]) VALUES (@Rotina, @Descricao);
SELECT ID, Rotina, Descricao FROM Telas WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rotina" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rotina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Rotina, Descricao FROM dbo.Telas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Telas] SET [Rotina] = @Rotina, [Descricao] = @Descricao WHERE (([ID] = @Original_ID) AND ((@IsNull_Rotina = 1 AND [Rotina] IS NULL) OR ([Rotina] = @Original_Rotina)) AND ((@IsNull_Descricao = 1 AND [Descricao] IS NULL) OR ([Descricao] = @Original_Descricao)));
SELECT ID, Rotina, Descricao FROM Telas WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rotina" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rotina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rotina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rotina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Rotina" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rotina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descricao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descricao" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HomeCare.dbo.Telas" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Rotina" DataSetColumn="Rotina" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TelefonesTableAdapter" GeneratorDataComponentClassName="TelefonesTableAdapter" Name="Telefones" UserDataComponentName="TelefonesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HomeCareConnection (Settings)" DbObjectName="HomeCare.dbo.Telefones" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Telefones] WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ((@IsNull_TipoTelefone = 1 AND [TipoTelefone] IS NULL) OR ([TipoTelefone] = @Original_TipoTelefone)) AND ((@IsNull_DDD = 1 AND [DDD] IS NULL) OR ([DDD] = @Original_DDD)) AND ((@IsNull_Numero = 1 AND [Numero] IS NULL) OR ([Numero] = @Original_Numero)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoTelefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoTelefone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoTelefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoTelefone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DDD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DDD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DDD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DDD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Numero" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Telefones] ([Pessoas_ID], [TipoTelefone], [DDD], [Numero]) VALUES (@Pessoas_ID, @TipoTelefone, @DDD, @Numero);
SELECT Pessoas_ID, TipoTelefone, DDD, Numero FROM Telefones WHERE (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoTelefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoTelefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DDD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DDD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Pessoas_ID, TipoTelefone, DDD, Numero FROM dbo.Telefones</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Telefones] SET [Pessoas_ID] = @Pessoas_ID, [TipoTelefone] = @TipoTelefone, [DDD] = @DDD, [Numero] = @Numero WHERE (([Pessoas_ID] = @Original_Pessoas_ID) AND ((@IsNull_TipoTelefone = 1 AND [TipoTelefone] IS NULL) OR ([TipoTelefone] = @Original_TipoTelefone)) AND ((@IsNull_DDD = 1 AND [DDD] IS NULL) OR ([DDD] = @Original_DDD)) AND ((@IsNull_Numero = 1 AND [Numero] IS NULL) OR ([Numero] = @Original_Numero)));
SELECT Pessoas_ID, TipoTelefone, DDD, Numero FROM Telefones WHERE (Pessoas_ID = @Pessoas_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoTelefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoTelefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DDD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DDD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Pessoas_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoas_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoTelefone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoTelefone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoTelefone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoTelefone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DDD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DDD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DDD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DDD" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Numero" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pessoas_ID" DataSetColumn="Pessoas_ID" />
              <Mapping SourceColumn="TipoTelefone" DataSetColumn="TipoTelefone" />
              <Mapping SourceColumn="DDD" DataSetColumn="DDD" />
              <Mapping SourceColumn="Numero" DataSetColumn="Numero" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="HomeCareDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="HomeCareDataSet" msprop:Generator_UserDSName="HomeCareDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Acessos" msprop:Generator_UserTableName="Acessos" msprop:Generator_RowDeletedName="AcessosRowDeleted" msprop:Generator_TableClassName="AcessosDataTable" msprop:Generator_RowChangedName="AcessosRowChanged" msprop:Generator_RowClassName="AcessosRow" msprop:Generator_RowChangingName="AcessosRowChanging" msprop:Generator_RowEvArgName="AcessosRowChangeEvent" msprop:Generator_RowEvHandlerName="AcessosRowChangeEventHandler" msprop:Generator_TablePropName="Acessos" msprop:Generator_TableVarName="tableAcessos" msprop:Generator_RowDeletingName="AcessosRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Telas_ID" msprop:Generator_UserColumnName="Telas_ID" msprop:Generator_ColumnPropNameInRow="Telas_ID" msprop:Generator_ColumnVarNameInTable="columnTelas_ID" msprop:Generator_ColumnPropNameInTable="Telas_IDColumn" type="xs:int" />
              <xs:element name="Perfis_ID" msprop:Generator_UserColumnName="Perfis_ID" msprop:Generator_ColumnPropNameInRow="Perfis_ID" msprop:Generator_ColumnVarNameInTable="columnPerfis_ID" msprop:Generator_ColumnPropNameInTable="Perfis_IDColumn" type="xs:int" />
              <xs:element name="Alteracao" msprop:Generator_UserColumnName="Alteracao" msprop:Generator_ColumnPropNameInRow="Alteracao" msprop:Generator_ColumnVarNameInTable="columnAlteracao" msprop:Generator_ColumnPropNameInTable="AlteracaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Consulta" msprop:Generator_UserColumnName="Consulta" msprop:Generator_ColumnPropNameInRow="Consulta" msprop:Generator_ColumnVarNameInTable="columnConsulta" msprop:Generator_ColumnPropNameInTable="ConsultaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Exclusao" msprop:Generator_UserColumnName="Exclusao" msprop:Generator_ColumnPropNameInRow="Exclusao" msprop:Generator_ColumnVarNameInTable="columnExclusao" msprop:Generator_ColumnPropNameInTable="ExclusaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Inclusao" msprop:Generator_UserColumnName="Inclusao" msprop:Generator_ColumnPropNameInRow="Inclusao" msprop:Generator_ColumnVarNameInTable="columnInclusao" msprop:Generator_ColumnPropNameInTable="InclusaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Agenda" msprop:Generator_UserTableName="Agenda" msprop:Generator_RowDeletedName="AgendaRowDeleted" msprop:Generator_TableClassName="AgendaDataTable" msprop:Generator_RowChangedName="AgendaRowChanged" msprop:Generator_RowClassName="AgendaRow" msprop:Generator_RowChangingName="AgendaRowChanging" msprop:Generator_RowEvArgName="AgendaRowChangeEvent" msprop:Generator_RowEvHandlerName="AgendaRowChangeEventHandler" msprop:Generator_TablePropName="Agenda" msprop:Generator_TableVarName="tableAgenda" msprop:Generator_RowDeletingName="AgendaRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Funcionario_ID" msprop:Generator_UserColumnName="Funcionario_ID" msprop:Generator_ColumnPropNameInRow="Funcionario_ID" msprop:Generator_ColumnVarNameInTable="columnFuncionario_ID" msprop:Generator_ColumnPropNameInTable="Funcionario_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DtFinal" msprop:Generator_UserColumnName="DtFinal" msprop:Generator_ColumnPropNameInRow="DtFinal" msprop:Generator_ColumnVarNameInTable="columnDtFinal" msprop:Generator_ColumnPropNameInTable="DtFinalColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DtInicial" msprop:Generator_UserColumnName="DtInicial" msprop:Generator_ColumnPropNameInRow="DtInicial" msprop:Generator_ColumnVarNameInTable="columnDtInicial" msprop:Generator_ColumnPropNameInTable="DtInicialColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Bairros" msprop:Generator_UserTableName="Bairros" msprop:Generator_RowDeletedName="BairrosRowDeleted" msprop:Generator_TableClassName="BairrosDataTable" msprop:Generator_RowChangedName="BairrosRowChanged" msprop:Generator_RowClassName="BairrosRow" msprop:Generator_RowChangingName="BairrosRowChanging" msprop:Generator_RowEvArgName="BairrosRowChangeEvent" msprop:Generator_RowEvHandlerName="BairrosRowChangeEventHandler" msprop:Generator_TablePropName="Bairros" msprop:Generator_TableVarName="tableBairros" msprop:Generator_RowDeletingName="BairrosRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Cidades_ID" msprop:Generator_UserColumnName="Cidades_ID" msprop:Generator_ColumnPropNameInRow="Cidades_ID" msprop:Generator_ColumnVarNameInTable="columnCidades_ID" msprop:Generator_ColumnPropNameInTable="Cidades_IDColumn" type="xs:int" />
              <xs:element name="Bairro" msprop:Generator_UserColumnName="Bairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInTable="BairroColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Cidades" msprop:Generator_UserTableName="Cidades" msprop:Generator_RowDeletedName="CidadesRowDeleted" msprop:Generator_TableClassName="CidadesDataTable" msprop:Generator_RowChangedName="CidadesRowChanged" msprop:Generator_RowClassName="CidadesRow" msprop:Generator_RowChangingName="CidadesRowChanging" msprop:Generator_RowEvArgName="CidadesRowChangeEvent" msprop:Generator_RowEvHandlerName="CidadesRowChangeEventHandler" msprop:Generator_TablePropName="Cidades" msprop:Generator_TableVarName="tableCidades" msprop:Generator_RowDeletingName="CidadesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Estados_ID" msprop:Generator_UserColumnName="Estados_ID" msprop:Generator_ColumnPropNameInRow="Estados_ID" msprop:Generator_ColumnVarNameInTable="columnEstados_ID" msprop:Generator_ColumnPropNameInTable="Estados_IDColumn" type="xs:int" />
              <xs:element name="Cidade" msprop:Generator_UserColumnName="Cidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Enderecos" msprop:Generator_UserTableName="Enderecos" msprop:Generator_RowDeletedName="EnderecosRowDeleted" msprop:Generator_TableClassName="EnderecosDataTable" msprop:Generator_RowChangedName="EnderecosRowChanged" msprop:Generator_RowClassName="EnderecosRow" msprop:Generator_RowChangingName="EnderecosRowChanging" msprop:Generator_RowEvArgName="EnderecosRowChangeEvent" msprop:Generator_RowEvHandlerName="EnderecosRowChangeEventHandler" msprop:Generator_TablePropName="Enderecos" msprop:Generator_TableVarName="tableEnderecos" msprop:Generator_RowDeletingName="EnderecosRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Estados_ID" msprop:Generator_UserColumnName="Estados_ID" msprop:Generator_ColumnPropNameInRow="Estados_ID" msprop:Generator_ColumnVarNameInTable="columnEstados_ID" msprop:Generator_ColumnPropNameInTable="Estados_IDColumn" type="xs:int" />
              <xs:element name="Cidades_ID" msprop:Generator_UserColumnName="Cidades_ID" msprop:Generator_ColumnPropNameInRow="Cidades_ID" msprop:Generator_ColumnVarNameInTable="columnCidades_ID" msprop:Generator_ColumnPropNameInTable="Cidades_IDColumn" type="xs:int" />
              <xs:element name="Bairros_ID" msprop:Generator_UserColumnName="Bairros_ID" msprop:Generator_ColumnPropNameInRow="Bairros_ID" msprop:Generator_ColumnVarNameInTable="columnBairros_ID" msprop:Generator_ColumnPropNameInTable="Bairros_IDColumn" type="xs:int" />
              <xs:element name="Rua" msprop:Generator_UserColumnName="Rua" msprop:Generator_ColumnPropNameInRow="Rua" msprop:Generator_ColumnVarNameInTable="columnRua" msprop:Generator_ColumnPropNameInTable="RuaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Numero" msprop:Generator_UserColumnName="Numero" msprop:Generator_ColumnPropNameInRow="Numero" msprop:Generator_ColumnVarNameInTable="columnNumero" msprop:Generator_ColumnPropNameInTable="NumeroColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Complemento" msprop:Generator_UserColumnName="Complemento" msprop:Generator_ColumnPropNameInRow="Complemento" msprop:Generator_ColumnVarNameInTable="columnComplemento" msprop:Generator_ColumnPropNameInTable="ComplementoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Enfermidades" msprop:Generator_UserTableName="Enfermidades" msprop:Generator_RowDeletedName="EnfermidadesRowDeleted" msprop:Generator_TableClassName="EnfermidadesDataTable" msprop:Generator_RowChangedName="EnfermidadesRowChanged" msprop:Generator_RowClassName="EnfermidadesRow" msprop:Generator_RowChangingName="EnfermidadesRowChanging" msprop:Generator_RowEvArgName="EnfermidadesRowChangeEvent" msprop:Generator_RowEvHandlerName="EnfermidadesRowChangeEventHandler" msprop:Generator_TablePropName="Enfermidades" msprop:Generator_TableVarName="tableEnfermidades" msprop:Generator_RowDeletingName="EnfermidadesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Enfermidade" msprop:Generator_UserColumnName="Enfermidade" msprop:Generator_ColumnPropNameInRow="Enfermidade" msprop:Generator_ColumnVarNameInTable="columnEnfermidade" msprop:Generator_ColumnPropNameInTable="EnfermidadeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EquipeMedica" msprop:Generator_UserTableName="EquipeMedica" msprop:Generator_RowDeletedName="EquipeMedicaRowDeleted" msprop:Generator_TableClassName="EquipeMedicaDataTable" msprop:Generator_RowChangedName="EquipeMedicaRowChanged" msprop:Generator_RowClassName="EquipeMedicaRow" msprop:Generator_RowChangingName="EquipeMedicaRowChanging" msprop:Generator_RowEvArgName="EquipeMedicaRowChangeEvent" msprop:Generator_RowEvHandlerName="EquipeMedicaRowChangeEventHandler" msprop:Generator_TablePropName="EquipeMedica" msprop:Generator_TableVarName="tableEquipeMedica" msprop:Generator_RowDeletingName="EquipeMedicaRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="NomeEquipe" msprop:Generator_UserColumnName="NomeEquipe" msprop:Generator_ColumnPropNameInRow="NomeEquipe" msprop:Generator_ColumnVarNameInTable="columnNomeEquipe" msprop:Generator_ColumnPropNameInTable="NomeEquipeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Medico_Resp_ID" msprop:Generator_UserColumnName="Medico_Resp_ID" msprop:Generator_ColumnPropNameInRow="Medico_Resp_ID" msprop:Generator_ColumnVarNameInTable="columnMedico_Resp_ID" msprop:Generator_ColumnPropNameInTable="Medico_Resp_IDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EquipeMedica_has_Pessoas" msprop:Generator_UserTableName="EquipeMedica_has_Pessoas" msprop:Generator_RowDeletedName="EquipeMedica_has_PessoasRowDeleted" msprop:Generator_TableClassName="EquipeMedica_has_PessoasDataTable" msprop:Generator_RowChangedName="EquipeMedica_has_PessoasRowChanged" msprop:Generator_RowClassName="EquipeMedica_has_PessoasRow" msprop:Generator_RowChangingName="EquipeMedica_has_PessoasRowChanging" msprop:Generator_RowEvArgName="EquipeMedica_has_PessoasRowChangeEvent" msprop:Generator_RowEvHandlerName="EquipeMedica_has_PessoasRowChangeEventHandler" msprop:Generator_TablePropName="EquipeMedica_has_Pessoas" msprop:Generator_TableVarName="tableEquipeMedica_has_Pessoas" msprop:Generator_RowDeletingName="EquipeMedica_has_PessoasRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="EquipeMedica_ID" msprop:Generator_UserColumnName="EquipeMedica_ID" msprop:Generator_ColumnPropNameInRow="EquipeMedica_ID" msprop:Generator_ColumnVarNameInTable="columnEquipeMedica_ID" msprop:Generator_ColumnPropNameInTable="EquipeMedica_IDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Especialidades" msprop:Generator_UserTableName="Especialidades" msprop:Generator_RowDeletedName="EspecialidadesRowDeleted" msprop:Generator_TableClassName="EspecialidadesDataTable" msprop:Generator_RowChangedName="EspecialidadesRowChanged" msprop:Generator_RowClassName="EspecialidadesRow" msprop:Generator_RowChangingName="EspecialidadesRowChanging" msprop:Generator_RowEvArgName="EspecialidadesRowChangeEvent" msprop:Generator_RowEvHandlerName="EspecialidadesRowChangeEventHandler" msprop:Generator_TablePropName="Especialidades" msprop:Generator_TableVarName="tableEspecialidades" msprop:Generator_RowDeletingName="EspecialidadesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Especialidade" msprop:Generator_UserColumnName="Especialidade" msprop:Generator_ColumnPropNameInRow="Especialidade" msprop:Generator_ColumnVarNameInTable="columnEspecialidade" msprop:Generator_ColumnPropNameInTable="EspecialidadeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Registro" msprop:Generator_UserColumnName="Registro" msprop:Generator_ColumnPropNameInRow="Registro" msprop:Generator_ColumnVarNameInTable="columnRegistro" msprop:Generator_ColumnPropNameInTable="RegistroColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Estados" msprop:Generator_UserTableName="Estados" msprop:Generator_RowDeletedName="EstadosRowDeleted" msprop:Generator_TableClassName="EstadosDataTable" msprop:Generator_RowChangedName="EstadosRowChanged" msprop:Generator_RowClassName="EstadosRow" msprop:Generator_RowChangingName="EstadosRowChanging" msprop:Generator_RowEvArgName="EstadosRowChangeEvent" msprop:Generator_RowEvHandlerName="EstadosRowChangeEventHandler" msprop:Generator_TablePropName="Estados" msprop:Generator_TableVarName="tableEstados" msprop:Generator_RowDeletingName="EstadosRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sigla" msprop:Generator_UserColumnName="Sigla" msprop:Generator_ColumnPropNameInRow="Sigla" msprop:Generator_ColumnVarNameInTable="columnSigla" msprop:Generator_ColumnPropNameInTable="SiglaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Eventos" msprop:Generator_UserTableName="Eventos" msprop:Generator_RowDeletedName="EventosRowDeleted" msprop:Generator_TableClassName="EventosDataTable" msprop:Generator_RowChangedName="EventosRowChanged" msprop:Generator_RowClassName="EventosRow" msprop:Generator_RowChangingName="EventosRowChanging" msprop:Generator_RowEvArgName="EventosRowChangeEvent" msprop:Generator_RowEvHandlerName="EventosRowChangeEventHandler" msprop:Generator_TablePropName="Eventos" msprop:Generator_TableVarName="tableEventos" msprop:Generator_RowDeletingName="EventosRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idEventos" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="idEventos" msprop:Generator_ColumnPropNameInRow="idEventos" msprop:Generator_ColumnVarNameInTable="columnidEventos" msprop:Generator_ColumnPropNameInTable="idEventosColumn" type="xs:int" />
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Telas_ID" msprop:Generator_UserColumnName="Telas_ID" msprop:Generator_ColumnPropNameInRow="Telas_ID" msprop:Generator_ColumnVarNameInTable="columnTelas_ID" msprop:Generator_ColumnPropNameInTable="Telas_IDColumn" type="xs:int" />
              <xs:element name="DtEvento" msprop:Generator_UserColumnName="DtEvento" msprop:Generator_ColumnPropNameInRow="DtEvento" msprop:Generator_ColumnVarNameInTable="columnDtEvento" msprop:Generator_ColumnPropNameInTable="DtEventoColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Fotografias" msprop:Generator_UserTableName="Fotografias" msprop:Generator_RowDeletedName="FotografiasRowDeleted" msprop:Generator_TableClassName="FotografiasDataTable" msprop:Generator_RowChangedName="FotografiasRowChanged" msprop:Generator_RowClassName="FotografiasRow" msprop:Generator_RowChangingName="FotografiasRowChanging" msprop:Generator_RowEvArgName="FotografiasRowChangeEvent" msprop:Generator_RowEvHandlerName="FotografiasRowChangeEventHandler" msprop:Generator_TablePropName="Fotografias" msprop:Generator_TableVarName="tableFotografias" msprop:Generator_RowDeletingName="FotografiasRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Caminho" msprop:Generator_UserColumnName="Caminho" msprop:Generator_ColumnPropNameInRow="Caminho" msprop:Generator_ColumnVarNameInTable="columnCaminho" msprop:Generator_ColumnPropNameInTable="CaminhoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Historico" msprop:Generator_UserTableName="Historico" msprop:Generator_RowDeletedName="HistoricoRowDeleted" msprop:Generator_TableClassName="HistoricoDataTable" msprop:Generator_RowChangedName="HistoricoRowChanged" msprop:Generator_RowClassName="HistoricoRow" msprop:Generator_RowChangingName="HistoricoRowChanging" msprop:Generator_RowEvArgName="HistoricoRowChangeEvent" msprop:Generator_RowEvHandlerName="HistoricoRowChangeEventHandler" msprop:Generator_TablePropName="Historico" msprop:Generator_TableVarName="tableHistorico" msprop:Generator_RowDeletingName="HistoricoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Funcionario_ID" msprop:Generator_UserColumnName="Funcionario_ID" msprop:Generator_ColumnPropNameInRow="Funcionario_ID" msprop:Generator_ColumnVarNameInTable="columnFuncionario_ID" msprop:Generator_ColumnPropNameInTable="Funcionario_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Situacao_ID" msprop:Generator_UserColumnName="Situacao_ID" msprop:Generator_ColumnPropNameInRow="Situacao_ID" msprop:Generator_ColumnVarNameInTable="columnSituacao_ID" msprop:Generator_ColumnPropNameInTable="Situacao_IDColumn" type="xs:int" />
              <xs:element name="Medicamentos_ID" msprop:Generator_UserColumnName="Medicamentos_ID" msprop:Generator_ColumnPropNameInRow="Medicamentos_ID" msprop:Generator_ColumnVarNameInTable="columnMedicamentos_ID" msprop:Generator_ColumnPropNameInTable="Medicamentos_IDColumn" type="xs:int" />
              <xs:element name="DtHistorico" msprop:Generator_UserColumnName="DtHistorico" msprop:Generator_ColumnPropNameInRow="DtHistorico" msprop:Generator_ColumnVarNameInTable="columnDtHistorico" msprop:Generator_ColumnPropNameInTable="DtHistoricoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Procedimento" msprop:Generator_UserColumnName="Procedimento" msprop:Generator_ColumnPropNameInRow="Procedimento" msprop:Generator_ColumnVarNameInTable="columnProcedimento" msprop:Generator_ColumnPropNameInTable="ProcedimentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Medicamentos" msprop:Generator_UserTableName="Medicamentos" msprop:Generator_RowDeletedName="MedicamentosRowDeleted" msprop:Generator_TableClassName="MedicamentosDataTable" msprop:Generator_RowChangedName="MedicamentosRowChanged" msprop:Generator_RowClassName="MedicamentosRow" msprop:Generator_RowChangingName="MedicamentosRowChanging" msprop:Generator_RowEvArgName="MedicamentosRowChangeEvent" msprop:Generator_RowEvHandlerName="MedicamentosRowChangeEventHandler" msprop:Generator_TablePropName="Medicamentos" msprop:Generator_TableVarName="tableMedicamentos" msprop:Generator_RowDeletingName="MedicamentosRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Medicamento" msprop:Generator_UserColumnName="Medicamento" msprop:Generator_ColumnPropNameInRow="Medicamento" msprop:Generator_ColumnVarNameInTable="columnMedicamento" msprop:Generator_ColumnPropNameInTable="MedicamentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Classificacao" msprop:Generator_UserColumnName="Classificacao" msprop:Generator_ColumnPropNameInRow="Classificacao" msprop:Generator_ColumnVarNameInTable="columnClassificacao" msprop:Generator_ColumnPropNameInTable="ClassificacaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Perfis" msprop:Generator_UserTableName="Perfis" msprop:Generator_RowDeletedName="PerfisRowDeleted" msprop:Generator_TableClassName="PerfisDataTable" msprop:Generator_RowChangedName="PerfisRowChanged" msprop:Generator_RowClassName="PerfisRow" msprop:Generator_RowChangingName="PerfisRowChanging" msprop:Generator_RowEvArgName="PerfisRowChangeEvent" msprop:Generator_RowEvHandlerName="PerfisRowChangeEventHandler" msprop:Generator_TablePropName="Perfis" msprop:Generator_TableVarName="tablePerfis" msprop:Generator_RowDeletingName="PerfisRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Perfis" msprop:Generator_UserColumnName="Perfis" msprop:Generator_ColumnPropNameInRow="Perfis" msprop:Generator_ColumnVarNameInTable="columnPerfis" msprop:Generator_ColumnPropNameInTable="PerfisColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Pessoas" msprop:Generator_UserTableName="Pessoas" msprop:Generator_RowDeletedName="PessoasRowDeleted" msprop:Generator_TableClassName="PessoasDataTable" msprop:Generator_RowChangedName="PessoasRowChanged" msprop:Generator_RowClassName="PessoasRow" msprop:Generator_RowChangingName="PessoasRowChanging" msprop:Generator_RowEvArgName="PessoasRowChangeEvent" msprop:Generator_RowEvHandlerName="PessoasRowChangeEventHandler" msprop:Generator_TablePropName="Pessoas" msprop:Generator_TableVarName="tablePessoas" msprop:Generator_RowDeletingName="PessoasRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sexo" msprop:Generator_UserColumnName="Sexo" msprop:Generator_ColumnPropNameInRow="Sexo" msprop:Generator_ColumnVarNameInTable="columnSexo" msprop:Generator_ColumnPropNameInTable="SexoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DtNasc" msprop:Generator_UserColumnName="DtNasc" msprop:Generator_ColumnPropNameInRow="DtNasc" msprop:Generator_ColumnVarNameInTable="columnDtNasc" msprop:Generator_ColumnPropNameInTable="DtNascColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CPF" msprop:Generator_UserColumnName="CPF" msprop:Generator_ColumnPropNameInRow="CPF" msprop:Generator_ColumnVarNameInTable="columnCPF" msprop:Generator_ColumnPropNameInTable="CPFColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RG" msprop:Generator_UserColumnName="RG" msprop:Generator_ColumnPropNameInRow="RG" msprop:Generator_ColumnVarNameInTable="columnRG" msprop:Generator_ColumnPropNameInTable="RGColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Observacoes" msprop:Generator_UserColumnName="Observacoes" msprop:Generator_ColumnPropNameInRow="Observacoes" msprop:Generator_ColumnVarNameInTable="columnObservacoes" msprop:Generator_ColumnPropNameInTable="ObservacoesColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Login" msprop:Generator_UserColumnName="Login" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInTable="LoginColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Senha" msprop:Generator_UserColumnName="Senha" msprop:Generator_ColumnPropNameInRow="Senha" msprop:Generator_ColumnVarNameInTable="columnSenha" msprop:Generator_ColumnPropNameInTable="SenhaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Pessoas_has_Enfermidades" msprop:Generator_UserTableName="Pessoas_has_Enfermidades" msprop:Generator_RowDeletedName="Pessoas_has_EnfermidadesRowDeleted" msprop:Generator_TableClassName="Pessoas_has_EnfermidadesDataTable" msprop:Generator_RowChangedName="Pessoas_has_EnfermidadesRowChanged" msprop:Generator_RowClassName="Pessoas_has_EnfermidadesRow" msprop:Generator_RowChangingName="Pessoas_has_EnfermidadesRowChanging" msprop:Generator_RowEvArgName="Pessoas_has_EnfermidadesRowChangeEvent" msprop:Generator_RowEvHandlerName="Pessoas_has_EnfermidadesRowChangeEventHandler" msprop:Generator_TablePropName="Pessoas_has_Enfermidades" msprop:Generator_TableVarName="tablePessoas_has_Enfermidades" msprop:Generator_RowDeletingName="Pessoas_has_EnfermidadesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Enfermidades_ID" msprop:Generator_UserColumnName="Enfermidades_ID" msprop:Generator_ColumnPropNameInRow="Enfermidades_ID" msprop:Generator_ColumnVarNameInTable="columnEnfermidades_ID" msprop:Generator_ColumnPropNameInTable="Enfermidades_IDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Pessoas_has_Especialidades" msprop:Generator_UserTableName="Pessoas_has_Especialidades" msprop:Generator_RowDeletedName="Pessoas_has_EspecialidadesRowDeleted" msprop:Generator_TableClassName="Pessoas_has_EspecialidadesDataTable" msprop:Generator_RowChangedName="Pessoas_has_EspecialidadesRowChanged" msprop:Generator_RowClassName="Pessoas_has_EspecialidadesRow" msprop:Generator_RowChangingName="Pessoas_has_EspecialidadesRowChanging" msprop:Generator_RowEvArgName="Pessoas_has_EspecialidadesRowChangeEvent" msprop:Generator_RowEvHandlerName="Pessoas_has_EspecialidadesRowChangeEventHandler" msprop:Generator_TablePropName="Pessoas_has_Especialidades" msprop:Generator_TableVarName="tablePessoas_has_Especialidades" msprop:Generator_RowDeletingName="Pessoas_has_EspecialidadesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Especialidades_ID" msprop:Generator_UserColumnName="Especialidades_ID" msprop:Generator_ColumnPropNameInRow="Especialidades_ID" msprop:Generator_ColumnVarNameInTable="columnEspecialidades_ID" msprop:Generator_ColumnPropNameInTable="Especialidades_IDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Pessoas_has_Perfis" msprop:Generator_UserTableName="Pessoas_has_Perfis" msprop:Generator_RowDeletedName="Pessoas_has_PerfisRowDeleted" msprop:Generator_TableClassName="Pessoas_has_PerfisDataTable" msprop:Generator_RowChangedName="Pessoas_has_PerfisRowChanged" msprop:Generator_RowClassName="Pessoas_has_PerfisRow" msprop:Generator_RowChangingName="Pessoas_has_PerfisRowChanging" msprop:Generator_RowEvArgName="Pessoas_has_PerfisRowChangeEvent" msprop:Generator_RowEvHandlerName="Pessoas_has_PerfisRowChangeEventHandler" msprop:Generator_TablePropName="Pessoas_has_Perfis" msprop:Generator_TableVarName="tablePessoas_has_Perfis" msprop:Generator_RowDeletingName="Pessoas_has_PerfisRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Perfis_ID" msprop:Generator_UserColumnName="Perfis_ID" msprop:Generator_ColumnPropNameInRow="Perfis_ID" msprop:Generator_ColumnVarNameInTable="columnPerfis_ID" msprop:Generator_ColumnPropNameInTable="Perfis_IDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Situacao" msprop:Generator_UserTableName="Situacao" msprop:Generator_RowDeletedName="SituacaoRowDeleted" msprop:Generator_TableClassName="SituacaoDataTable" msprop:Generator_RowChangedName="SituacaoRowChanged" msprop:Generator_RowClassName="SituacaoRow" msprop:Generator_RowChangingName="SituacaoRowChanging" msprop:Generator_RowEvArgName="SituacaoRowChangeEvent" msprop:Generator_RowEvHandlerName="SituacaoRowChangeEventHandler" msprop:Generator_TablePropName="Situacao" msprop:Generator_TableVarName="tableSituacao" msprop:Generator_RowDeletingName="SituacaoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Situacao" msprop:Generator_UserColumnName="Situacao" msprop:Generator_ColumnPropNameInRow="Situacao" msprop:Generator_ColumnVarNameInTable="columnSituacao" msprop:Generator_ColumnPropNameInTable="SituacaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SMS" msprop:Generator_UserTableName="SMS" msprop:Generator_RowDeletedName="SMSRowDeleted" msprop:Generator_TableClassName="SMSDataTable" msprop:Generator_RowChangedName="SMSRowChanged" msprop:Generator_RowClassName="SMSRow" msprop:Generator_RowChangingName="SMSRowChanging" msprop:Generator_RowEvArgName="SMSRowChangeEvent" msprop:Generator_RowEvHandlerName="SMSRowChangeEventHandler" msprop:Generator_TablePropName="SMS" msprop:Generator_TableVarName="tableSMS" msprop:Generator_RowDeletingName="SMSRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="Operadora" msprop:Generator_UserColumnName="Operadora" msprop:Generator_ColumnPropNameInRow="Operadora" msprop:Generator_ColumnVarNameInTable="columnOperadora" msprop:Generator_ColumnPropNameInTable="OperadoraColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone" msprop:Generator_UserColumnName="Telefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mensagem" msprop:Generator_UserColumnName="Mensagem" msprop:Generator_ColumnPropNameInRow="Mensagem" msprop:Generator_ColumnVarNameInTable="columnMensagem" msprop:Generator_ColumnPropNameInTable="MensagemColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataEnvio" msprop:Generator_UserColumnName="DataEnvio" msprop:Generator_ColumnPropNameInRow="DataEnvio" msprop:Generator_ColumnVarNameInTable="columnDataEnvio" msprop:Generator_ColumnPropNameInTable="DataEnvioColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DDDTelefone" msprop:Generator_UserColumnName="DDDTelefone" msprop:Generator_ColumnPropNameInRow="DDDTelefone" msprop:Generator_ColumnVarNameInTable="columnDDDTelefone" msprop:Generator_ColumnPropNameInTable="DDDTelefoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Telas" msprop:Generator_UserTableName="Telas" msprop:Generator_RowDeletedName="TelasRowDeleted" msprop:Generator_TableClassName="TelasDataTable" msprop:Generator_RowChangedName="TelasRowChanged" msprop:Generator_RowClassName="TelasRow" msprop:Generator_RowChangingName="TelasRowChanging" msprop:Generator_RowEvArgName="TelasRowChangeEvent" msprop:Generator_RowEvHandlerName="TelasRowChangeEventHandler" msprop:Generator_TablePropName="Telas" msprop:Generator_TableVarName="tableTelas" msprop:Generator_RowDeletingName="TelasRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Rotina" msprop:Generator_UserColumnName="Rotina" msprop:Generator_ColumnPropNameInRow="Rotina" msprop:Generator_ColumnVarNameInTable="columnRotina" msprop:Generator_ColumnPropNameInTable="RotinaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Telefones" msprop:Generator_UserTableName="Telefones" msprop:Generator_RowDeletedName="TelefonesRowDeleted" msprop:Generator_TableClassName="TelefonesDataTable" msprop:Generator_RowChangedName="TelefonesRowChanged" msprop:Generator_RowClassName="TelefonesRow" msprop:Generator_RowChangingName="TelefonesRowChanging" msprop:Generator_RowEvArgName="TelefonesRowChangeEvent" msprop:Generator_RowEvHandlerName="TelefonesRowChangeEventHandler" msprop:Generator_TablePropName="Telefones" msprop:Generator_TableVarName="tableTelefones" msprop:Generator_RowDeletingName="TelefonesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pessoas_ID" msprop:Generator_UserColumnName="Pessoas_ID" msprop:Generator_ColumnPropNameInRow="Pessoas_ID" msprop:Generator_ColumnVarNameInTable="columnPessoas_ID" msprop:Generator_ColumnPropNameInTable="Pessoas_IDColumn" type="xs:int" />
              <xs:element name="TipoTelefone" msprop:Generator_UserColumnName="TipoTelefone" msprop:Generator_ColumnPropNameInRow="TipoTelefone" msprop:Generator_ColumnVarNameInTable="columnTipoTelefone" msprop:Generator_ColumnPropNameInTable="TipoTelefoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DDD" msprop:Generator_UserColumnName="DDD" msprop:Generator_ColumnPropNameInRow="DDD" msprop:Generator_ColumnVarNameInTable="columnDDD" msprop:Generator_ColumnPropNameInTable="DDDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Numero" msprop:Generator_UserColumnName="Numero" msprop:Generator_ColumnPropNameInRow="Numero" msprop:Generator_ColumnVarNameInTable="columnNumero" msprop:Generator_ColumnPropNameInTable="NumeroColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Acessos" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Agenda_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Agenda" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Bairros_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Bairros" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Cidades_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cidades" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Enderecos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Enderecos" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Enfermidades_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Enfermidades" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="EquipeMedica_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EquipeMedica" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="EquipeMedica_has_Pessoas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EquipeMedica_has_Pessoas" />
      <xs:field xpath="mstns:Pessoas_ID" />
      <xs:field xpath="mstns:EquipeMedica_ID" />
    </xs:unique>
    <xs:unique name="Especialidades_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Especialidades" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Estados_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Estados" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Eventos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Eventos" />
      <xs:field xpath="mstns:idEventos" />
    </xs:unique>
    <xs:unique name="Fotografias_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Fotografias" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Medicamentos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Medicamentos" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Perfis_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Perfis" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Pessoas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Pessoas" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Pessoas_has_Enfermidades_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Pessoas_has_Enfermidades" />
      <xs:field xpath="mstns:Pessoas_ID" />
      <xs:field xpath="mstns:Enfermidades_ID" />
    </xs:unique>
    <xs:unique name="Pessoas_has_Especialidades_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Pessoas_has_Especialidades" />
      <xs:field xpath="mstns:Pessoas_ID" />
      <xs:field xpath="mstns:Especialidades_ID" />
    </xs:unique>
    <xs:unique name="Pessoas_has_Perfis_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Pessoas_has_Perfis" />
      <xs:field xpath="mstns:Pessoas_ID" />
      <xs:field xpath="mstns:Perfis_ID" />
    </xs:unique>
    <xs:unique name="Situacao_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Situacao" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="SMS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SMS" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Telas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Telas" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Telefones_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Telefones" />
      <xs:field xpath="mstns:Pessoas_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>